Tabela Material

Definicja tabeli Material

Name

Material

Code

Material

Comment

 


Lista kolumn tabeli Material

Name

Code

MaterialID

MaterialID

MaterialTypeID

MaterialTypeID

Active

Active


Kolumna MaterialID tabeli Material

Definicja kolumny MaterialID tabeli Material

Name

MaterialID

Code

MaterialID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna MaterialTypeID tabeli Material

Definicja kolumny MaterialTypeID tabeli Material

Name

MaterialTypeID

Code

MaterialTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Active tabeli Material

Definicja kolumny Active tabeli Material

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Lista kluczy tabeli Material

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Material

Definicja klucza Identifier_1 tabeli Material

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment